Diagram OCM_Defs_Service

Defincja diagramu OCM_Defs_Service

Name

OCM_Defs_Service

Code

OCM_Defs_Service

Comment

 


Lista tabel diagramu

Name

Code

ActionType

ActionType

ActionTypeText

ActionTypeText

ExternalDoctor

ExternalDoctor

ExternalOrgUnit

ExternalOrgUnit

FormDefinition

FormDefinition

Frequency

Frequency

Language

Language

LFrequencyTimeTemplate

LFrequencyTimeTemplate

LOrgUnitServ

LOrgUnitServ

LPatMaterialFormInstance

LPatMaterialFormInstance

LPatMaterialStatus

LPatMaterialStatus

LPatMaterialTreeRoot

LPatMaterialTreeRoot

LPerfServicePatMaterial

LPerfServicePatMaterial

LPerfServiceStatus

LPerfServiceStatus

LPerfSeviceStopOrder

LPerfSeviceStopOrder

LServiceFrequency

LServiceFrequency

LServiceMaterial

LServiceMaterial

LServicePack

LServicePack

LServicePatMaterial4Coding

LServicePatMaterial4Coding

LServiceStatus

LServiceStatus

LServiceStatusActionType

LServiceStatusActionType

Material

Material

MaterialType

MaterialType

MaterialTypeText

MaterialTypeText

PathomorphologyMaterial

PathomorphologyMaterial

PatMaterial

PatMaterial

PatMaterialIdentifier

PatMaterialIdentifier

PatMaterialStatus

PatMaterialStatus

PatMaterialStatusText

PatMaterialStatusText

PatMaterialTree

PatMaterialTree

PatMaterialType

PatMaterialType

PatMaterialTypeText

PatMaterialTypeText

PatStructure

PatStructure

PatStructureType

PatStructureType

PatStructureTypeText

PatStructureTypeText

PerfService

PerfService

PerfServiceStatus

PerfServiceStatus

PerfServiceStopOrder

PerfServiceStopOrder

PerfServStatusText

PerfServStatusText

Person

Person

PreserveMethod

PreserveMethod

PreserveMethodText

PreserveMethodText

ResourceItem

ResourceItem

Service

Service

ServiceAddOns

ServiceAddOns

ServicePack

ServicePack

TimeTemplate

TimeTemplate

VisitCancelReason

VisitCancelReason


Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_150

R_150

Language

PerfServStatusText

LanguageID

 

 

R_164

R_164

PerfServiceStatus

PerfServiceStopOrder

PerfServiceStatusID

 

 

R_174

R_174

Frequency

LFrequencyTimeTemplate

FrequencyID

 

 

R_176

R_176

TimeTemplate

LFrequencyTimeTemplate

TimeTemplateID

 

 

R_186

R_186

Service

LOrgUnitServ

ServID

 

 

R_585

R_585

Service

ServiceAddOns

ServID

 

 

R_586

R_586

PerfServiceStatus

LServiceStatus

PerfServiceStatusID

 

 

R_587

R_587

Service

LServiceStatus

ServID

 

 

R_657

R_657

Language

ActionTypeText

LanguageID

 

 

R_659

R_659

ActionType

ActionTypeText

ActionTypeID

 

 

R_669

R_669

PerfServiceStatus

PerfServStatusText

PerfServiceStatusID

 

 

R_733

R_733

PerfServiceStatus

LPerfServiceStatus

PerfServiceStatusID

 

 

R_734

R_734

PerfService

LPerfServiceStatus

PerfServiceID

 

 

R_755

R_755

ActionType

LServiceStatusActionType

ActionTypeID

 

 

R_756

R_756

LServiceStatus

LServiceStatusActionType

ServID; PerfServiceStatusID

 

 

R_785

R_785

Material

LServiceMaterial

MaterialID

 

 

R_786

R_786

Service

LServiceMaterial

ServID

 

 

R_906

R_906

Frequency

PerfService

FrequencyID

 

 

R_914

R_914

PerfServiceStatus

PerfServiceStatus

Per_PerfServiceStatusID

 

 

R_928

R_928

PerfService

LPerfSeviceStopOrder

PerfServiceID

 

 

R_929

R_929

PerfServiceStopOrder

LPerfSeviceStopOrder

PerfServiceStopOrderID

 

 

R_931

R_931

PerfServiceStatus

PerfServiceStopOrder

Per_PerfServiceStatusID

 

 

R_933

R_933

LFrequencyTimeTemplate

LServiceMaterial

TimeTemplateID; FrequencyID

 

 

R_940

R_940

Service

LServiceFrequency

ServID

 

 

R_941

R_941

Frequency

LServiceFrequency

FrequencyID

 

 

R_1106

R_1106

ServicePack

LServicePack

ServicePackID

 

 

R_1107

R_1107

Service

LServicePack

ServID

 

 

R_1108

R_1108

ResourceItem

LServicePack

ResourceID

 

 

R_1567

R_1567

MaterialType

MaterialTypeText

MaterialTypeID

 

 

R_1568

R_1568

Language

MaterialTypeText

LanguageID

 

 

R_1569

R_1569

MaterialType

Material

MaterialTypeID

 

 

R_1730

R_1730

VisitCancelReason

LPerfServiceStatus

VisitCancelReasonID

 

 

R_4070

R_4070

FormDefinition

PathomorphologyMaterial

FormDefinitionID

 

 

R_9380

R_9380

PatMaterialType

PatMaterialTypeText

PatMaterialTypeID

 

 

R_9381

R_9381

PreserveMethod

PreserveMethodText

PreserveMethodID

 

 

R_9382

R_9382

PatStructureType

PatStructureTypeText

PatStructureTypeID

 

 

R_9383

R_9383

PatMaterialStatus

PatMaterialStatusText

PatMaterialStatusID

 

 

R_9384

R_9384

PatMaterialType

PatMaterialStatus

PatMaterialTypeID

 

 

R_9385

R_9385

PatStructure

PatStructure

ParentID

 

 

R_9386

R_9386

PatStructureType

PatStructure

PatStructureTypeID

 

 

R_9387

R_9387

FormDefinition

PatStructure

FormDefinitionID

 

 

R_9388

R_9388

PatMaterial

PatMaterial

ParentID

 

 

R_9389

R_9389

PatMaterialType

PatMaterial

PatMaterialTypeID

 

 

R_9390

R_9390

PatMaterialStatus

PatMaterial

PatMaterialStatusID

 

 

R_9391

R_9391

ExternalDoctor

PatMaterial

CreatingPerson

 

 

R_9392

R_9392

ExternalOrgUnit

PatMaterial

CreatingOrgUnit

 

 

R_9393

R_9393

PatStructure

PatMaterial

PatStructureOrgan

 

 

R_9394

R_9394

PatStructure

PatMaterial

PatStructureTopography

 

 

R_9395

R_9395

PatStructure

PatMaterial

PatStructureMaterial

 

 

R_9396

R_9396

FormDefinition

PatMaterial

MacroFormInstanceID

 

 


2